OpenEdge Data Management:<br />SQL Reference LCASE

Release 10.1A: OpenEdge Data Management:
SQL Reference

LCASE

Returns the result of the argument character expression after converting all the characters to lowercase. LCASE is the same as LOWER but provides ODBC-compatible syntax.

Syntax
LCASE ( char_expression ) 
Example

This example illustrates the LCASE function:
SELECT * 
    FROM customer 
    WHERE LCASE (last_name) = 'smith' ; 
Notes

The argument to the function must be of type CHARACTER.

The result is of type CHARACTER.

If the argument expression evaluates to NULL, the result is NULL.

A char_expression and the result can contain multi-byte characters. The lowercase conversion is determined by the case table in the convmap file. The default case table is BASIC.

Compatibility

ODBC compatible